2012-11-05 - 5194.100 - Service Request - Inventory on hand does not match GL 1410 #FIPP
Summary Description
Inventory on hand does not match GL 1410
Admin Info
| Purpose |
Inventory on hand does not match GL 1410 |
| Requested by |
Mike Williams |
| Issue Date |
11/5/2012 |
| Resolved by |
Sai Valisetti |
| Resolved Date |
11/5/2012 |
| Document Status |
Complete |
Detailed Description
(Include Screen Shots if required )Inventory on hand report does not match inventory GL posting for Miami plants.
Analysis and Recommendations
(Include Screen Shots if required)In the existing system we are comparing MB52 with RFSSLD00 and currently difference between stock and G/L is 17M +/-(this value changes quite often as inventory moment changes).
I am using the RM07MBST(RM07MMFI) to see the difference for inventory and G/L postings..
For Finished products, warehouse stock value occurred due to Logistics is 6,427,791.24 USD and the account value that is posted to the account is 20,789,616.22 USD, this value is posted to the account with document types (SA,PR,WA,WE,WL). Except SA document type all the document types happened automatically. SA document type is a manual postings which is 14,361,824.98 USD.
For Raw materials, warehouse stock value occurred due to Logistics are 684,260.40 USD and the account value that is posted to the account is 3,399,065.71 USD, this value is posted to the account with document types (SA,PR,WA,WE,WL). Except SA document type all the document types happened automatically. SA document type is a manual postings which is 2,714,805.31 USD.
17M $ difference occurred due to the manual postings for the accounts 135110, 135100 with the SA document type. Detailed Analysis can be found in the attached document.
Analyzed the manual postings to check the validity of differential postings(17M) back to the inventory (if Mike want post this way).
Inventory Does not match the GL.doc
On hand report differences.xls
Resolution
For Finished products- SA document type that last used is 04 month of this year.. from that month onwards this value has been 14M . If there is no manual postings happens in the future there should not me much change. If there is a change then it can happened due to the price change of the material after posting the stock(this variation you can see for any company code)(price change happens before posting the stock then it won’t have any effect). In any case any difference of value is not difficult to analyze.
Afer running fbl3n report last used SA document type is on date 04.2012 for account 135110
when I run RM07MBST for this current period still the value of the above you are seeing did not change but value of inventory and G/L account value changed.
Current period(11/2012):
Requested Mike to start using the program that I mentioned aboveCurrently he is down loading and doing manual calculations and the comparing with the report that inventory keep on changing
Release Information
Provide link here to Release Notes